home *** CD-ROM | disk | FTP | other *** search
/ Everything You Wanted To…now: Microsoft Access 7.0 / Everything You Wanted to Know: Microsoft Access 7.0.iso / iacces22.avi (.mp4) < prev    next >
Audio Video Interleaved Video  |  1995-12-11  |  57.3 MB  |  320x240  |  15fps  |  6 minutes, 28 seconds
Transcription: Next you'll see how to use a query to select just certain records, records that meet criteria that you set. We want to see a list of all invoices that have not been paid. We'll create a DynaSet of unpaid invoices, showing the invoice number, the amount paid, and the due date. We open the New Query dialog box and click on OK. All the data we need is in the Invoices table. So we double click on it to select it. And then close the Show Table dialog box. We double click on each of the fields we want to add to the query. Invoice number, amount paid, and due date. We want the query to select only th ...